Basic Statistics

For calculating the statistical properties of a data set the data must entered in the 1. the input table. The result of each collumn will be displayed in the underlying result array 3. and Graph image 2.

1. Input table

Input Table for the data to be analyzed. If a data point is out of tolerance the text will be colored red, the tolerance borders must be entered in the result array 3.. If a data point is a outlayer the cell is gray and for a extreme outlayer dark gray. In the legend is in 6..
The amount of decimals behind the point can be changed in the box in the upper left corner.

2. Graphs

The graph of the data set is life updated after data is entered. With the graph selector 8. the type of graph can be chosen. The graph can be made invisible or visible with the selector in the upper left corner Graph. By clicking on a graph a bigger version of the graph will be displayed in a pop-up.

3. Result table

In this table the result will be displayed according the selection in the selection area 9.. For comparing data sets put in the comparing column in the first row the comparing column and this will be used for; t-test, F-test, and correlation calculations.
Row 2-4 is for the tolerance borders and nominal value, these will be displayed in the graphs and used for; Cp, Cpk and the % out of tolerance calculation.

9. Selection area

In the selection area the calculation to be executed can be selected.

Mean	Mean
n	Size of data set
Median	Median
STDEV	Standardevidation
% Cp Cpk	Cp Cpk % out of tolerance
Difference	Difference in mean with the comparing Column
t-test	Test for difference in mean
Normality test	Checks if the data set is distributed according the normal distribution.
F-test	Test for difference in variation
Kurtois	If the data set is flat or peaked distributed
Skewness	If the data set is symmetrical distributed
Correlation	Correlation between 2 data sets and the Regression
Min/Max	Shows the minimum and maximum value

5. Statistical mode

When selecting DOE the DOE layout will be displayed.

What statistical tests

Test what	With what statistical test
Difference in Mean	t-test
Difference in Mean between multiple data sets	One way Anova
Difference in Variation	Variation F-test
If data set is normal distributed	Anderson Darling normality test
Is the data according specification	Cp Cpk % out of tolerance
If there is relation between two data sets	Correlation
Calculates the relation between data sets	Regression
Difference in two proportions (Data set with only good or false results)	Proportions